
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE ID = OBJECT_ID(N'tTTTTT') and OBJECTPROPERTY(ID, N'IsUserTable') = 1) BEGIN

   -- Create Employee 1:N table
   CREATE TABLE [tTTTTT] (
   	[PPPPP] INT IDENTITY (1, 1) NOT NULL ,
   	[PID] INT NOT NULL ,
   	
      ... Your field list here ...
   
      -- Create non-clustered primary key
   	CONSTRAINT [rpk_TTTTT] PRIMARY KEY NONCLUSTERED 
   	(
   		[PPPPP]
   	)  ON [PRIMARY] ,
   ) ON [PRIMARY]

END








